{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Input","Output","Transmission","Compatibility","Interconnection","Cost per Section","Cost Distance drop","Demography"],"not_rendered":{"charts":4,"images":18,"macros":1,"external_links":0,"defined_names":96,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":18,"n_cols":18,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,17],[3,2,3,9]]}
[]
[null,"Metro-Access Network Dimensioning"]
[]
[null,"Zone name","Simulateur v1.0"]
[]
[null,null,"Data",null,null,null,null,null,null,null,"Metro","POP","Feeder","\"Manhole\"","Drop","BEP","In-house","Home"]
[null,"Surface",25.02,null,null,null,null,null,null,"Actual",1,23,13,3,3,5,6,8]
[null,"Nb. Central Offices",10,null,null,null,null,null,null,"Compatibility",{"$f":"IF(ISNA(MATCH(act_metro&\";\"&act_pop,TableCompatibility[Lookup],0)),\"NOK\",\"OK\")","v":"OK"},{"$f":"IF(ISNA(MATCH(act_feeder&\";\"&act_pop,TableCompatibility[Lookup],0)),\"NOK\",\"OK\")","v":"OK"},{"$f":"IF(ISNA(MATCH(act_feeder&\";\"&act_manhole,TableCompatibility[Lookup],0)),\"NOK\",\"OK\")","v":"OK"},{"$f":"IF(ISNA(MATCH(act_drop&\";\"&act_manhole,TableCompatibility[Lookup],0)),\"NOK\",\"OK\")","v":"OK"},{"$f":"IF(ISNA(MATCH(act_drop&\";\"&act_bep,TableCompatibility[Lookup],0)),\"NOK\",\"OK\")","v":"OK"},{"$f":"IF(ISNA(MATCH(act_inhouse&\";\"&act_bep,TableCompatibility[Lookup],0)),\"NOK\",\"OK\")","v":"OK"},{"$f":"IF(ISNA(MATCH(act_inhouse&\";\"&act_home,TableCompatibility[Lookup],0)),\"NOK\",\"OK\")","v":"OK"}]
[null,"Linear factor feeder",1.5,null,null,null,null,null,null,"Future",1,24,13,9,3,5,6,10]
[null,"Linear factor drop",2,null,null,null,null,null,null,"Compatibility",{"$f":"IF(ISNA(MATCH(fut_metro&\";\"&fut_pop,TableCompatibility[Lookup],0)),\"NOK\",\"OK\")","v":"OK"},{"$f":"IF(ISNA(MATCH(fut_feeder&\";\"&fut_pop,TableCompatibility[Lookup],0)),\"NOK\",\"OK\")","v":"OK"},{"$f":"IF(ISNA(MATCH(fut_feeder&\";\"&fut_manhole,TableCompatibility[Lookup],0)),\"NOK\",\"OK\")","v":"OK"},{"$f":"IF(ISNA(MATCH(fut_drop&\";\"&fut_manhole,TableCompatibility[Lookup],0)),\"NOK\",\"OK\")","v":"OK"},{"$f":"IF(ISNA(MATCH(fut_drop&\";\"&fut_bep,TableCompatibility[Lookup],0)),\"NOK\",\"OK\")","v":"OK"},{"$f":"IF(ISNA(MATCH(fut_inhouse&\";\"&fut_bep,TableCompatibility[Lookup],0)),\"NOK\",\"OK\")","v":"OK"},{"$f":"IF(ISNA(MATCH(fut_inhouse&\";\"&fut_home,TableCompatibility[Lookup],0)),\"NOK\",\"OK\")","v":"OK"}]
[null,"In-house average",0.03]
[]
[null,null,"Actual","Future"]
[null,"Year",2013,2025]
[null,"Lodgment",95725,97500]
[null,"Building",18672,19000]
[null,"Distance metro",10,10]
[null,"Distance drop max",0.35,0.1]

{"sheet":"Output","index":1,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,10],[10,1,10,4],[10,9,10,10],[10,6,10,7],[3,1,3,10],[5,2,5,10],[8,2,8,10],[7,2,7,10],[6,2,6,10]]}
[]
[null,"Metro-Access Network Dimensioning"]
[]
[null,"Simulation result page"]
[]
[null,"Zone",{"$f":"ZoneName","v":"Simulateur v1.0"}]
[null,"Base year",{"$f":"act_year","v":2013}]
[null,"Projected year",{"$f":"fut_year","v":2025}]
[null,"Simulation date",{"$f":"TODAY()","v":"2015-01-25"}]
[]
[null,"Detailed results",null,null,null,null,"Detailled costs",null,null,"Final costs"]
[]
[null,"Nb. CO (Central Offices)",{"$f":"nb_pops","v":10},null,null,null,"Cost metro",{"$f":"IF(act_metro=fut_metro,(dst_metro_fut-dst_metro_act)*LOOKUP(fut_metro, TableTransmission[ID], TableTransmission[Total km cost]),dst_metro_fut*LOOKUP(fut_metro, TableTransmission[ID], TableTransmission[Total km cost]))","v":0},null,"Total per building",{"$f":"(cost_metro+cost_pop+cost_feeder+cost_manhole+cost_drop+cost_bep)/fut_building","v":1427.0478720958574}]
[null,"Surface per CO",{"$f":"Surface/nb_pops","v":2.5019999999999998},null,null,null,"Cost POP",{"$f":"IF(act_pop=fut_pop,(nb_pop_fut-nb_pop_act)*LOOKUP(fut_pop,TableInterconnection[ID],TableInterconnection[Total initial cost]),nb_pop_fut*LOOKUP(fut_pop,TableInterconnection[ID],TableInterconnection[Total initial cost]))","v":1998000},null,"Total per lodgment",{"$f":"final_cost_metroaccess/fut_lodgment","v":428.09138020329527}]
[null,"Distance CO to manhole",{"$f":"SQRT(sur_per_centr/PI())*linear_factor_feeder","v":1.3386282173447748},null,null,null,"Cost feeder",{"$f":"IF(act_feeder=fut_feeder,IF((dst_feeder_fut-dst_feeder_act)<0,0,(dst_feeder_fut-dst_feeder_act))*LOOKUP(fut_feeder, TableTransmission[ID], TableTransmission[Total km cost]),dst_feeder_fut*LOOKUP(fut_feeder, TableTransmission[ID], TableTransmission[Total km cost]))","v":7900709.5698212907},null,"Total metro",{"$f":"cost_metro","v":0}]
[null,null,null,null,null,null,"Cost \"Manhole\"",{"$f":"IF(act_manhole=fut_manhole,IF((nb_manhole_elt_fut-nb_manhole_elt_act)<0,0,(nb_manhole_elt_fut-nb_manhole_elt_act))*(LOOKUP(fut_manhole,TableInterconnection[ID],TableInterconnection[Initial cost per port]))*LOOKUP(fut_manhole,TableInterconnection[ID],TableInterconnection[Ports per unit])+IF((nb_manhole_fut-nb_manhole_act)<0,0,(nb_manhole_fut-nb_manhole_act))*LOOKUP(fut_manhole,TableInterconnection[ID],TableInterconnection[Installation cost]),nb_manhole_elt_fut*((LOOKUP(fut_manhole,TableInterconnection[ID],TableInterconnection[Initial cost per port]))*LOOKUP(fut_manhole,TableInterconnection[ID],TableInterconnection[Ports per unit]))+nb_manhole_fut*LOOKUP(fut_manhole,TableInterconnection[ID],TableInterconnection[Installation cost]))","v":17215200},null,"Total access",{"$f":"final_cost_drop+final_cost_feeder","v":27113909.569821291}]
[null,null,"Actual","Future","Delta",null,"Cost drop",{"$f":"IF(act_drop=fut_drop,IF((dst_drop_fut-dst_drop_act)<0,0,(dst_drop_fut-dst_drop_act))*LOOKUP(fut_drop,TableTransmission[ID],TableTransmission[Total km cost]),dst_drop_fut*LOOKUP(fut_drop,TableTransmission[ID],TableTransmission[Total km cost]))","v":0},null,"Total drop",{"$f":"cost_bep+cost_drop+cost_manhole","v":17215200}]
[null,"Nb. brick POP",{"$f":"ROUNDUP(nb_manhole_elt_act/LOOKUP(act_pop, TableInterconnection[ID],TableInterconnection[Ports per unit])/nb_co,0)*nb_co","v":10},{"$f":"ROUNDUP(nb_manhole_elt_fut/LOOKUP(fut_pop, TableInterconnection[ID],TableInterconnection[Ports per unit])/nb_co,0)*nb_co","v":30},{"$f":"(100-(100/nb_pop_fut*nb_pop_act))/100","v":0.66666666666666652},null,"Cost BEP",{"$f":"IF(act_bep=fut_bep,(fut_building-act_building)*LOOKUP(fut_bep,TableInterconnection[ID],TableInterconnection[Total initial cost]),fut_building*LOOKUP(fut_bep,TableInterconnection[ID],TableInterconnection[Total initial cost]))","v":0},null,"Total feeder",{"$f":"cost_feeder+cost_pop","v":9898709.5698212907}]
[null,"Distance total metro",{"$f":"in_dst_metro_act","v":10},{"$f":"in_dst_metro_fut","v":10},{"$f":"(100-(100/dst_metro_fut*dst_metro_act))/100","v":0},null,"Cost In-House",{"$f":"IF(act_inhouse=fut_inhouse,(dst_inhouse_fut-dst_inhouse_act)*LOOKUP(fut_inhouse, TableTransmission[ID],TableTransmission[Total km cost]),dst_inhouse_fut*LOOKUP(fut_inhouse, TableTransmission[ID],TableTransmission[Total km cost]))","v":0},null,"Total In-House",{"$f":"cost_inhouse","v":0}]
[null,"Distance total feeder",{"$f":"dst_centr_lodg*nb_manhole_act","v":88.349462344755139},{"$f":"dst_centr_lodg*nb_manhole_fut","v":1066.8866892237854},{"$f":"(100-(100/dst_feeder_fut*dst_feeder_act))/100","v":0.91718946047678795},null,"Cost Home",{"$f":"IF(act_home=fut_home,(fut_lodgment-act_lodgment)*LOOKUP(fut_home,TableInterconnection[ID],TableInterconnection[Total initial cost]),fut_lodgment*LOOKUP(fut_home,TableInterconnection[ID],TableInterconnection[Total initial cost]))","v":14625000},null,"In-House per lodgment",{"$f":"final_cost_inhouse/fut_lodgment","v":0}]
[null,"Distance total drop",{"$f":"drop_dst_act*act_building","v":6535.2},{"$f":"drop_dst_fut*fut_building","v":1900},{"$f":"(100-(100/dst_drop_fut*dst_drop_act))/100","v":-2.4395789473684211},null,null,null,null,"Total House",{"$f":"cost_home","v":14625000}]
[null,"Distance mean drop",{"$f":"dist_drop_max_act*linear_factor_drop/2","v":0.35},{"$f":"dist_drop_max_fut*linear_factor_drop/2","v":0.1},{"$f":"(100-(100/drop_dst_fut*drop_dst_act))/100","v":-2.5},null,null,null,null,"House per lodgment",{"$f":"final_cost_home/fut_lodgment","v":150}]
[null,"Distance in-house",{"$f":"inhouse_average*act_lodgment","v":2871.75},{"$f":"inhouse_average*fut_lodgment","v":2925},{"$f":"(100-(100/dst_inhouse_fut*dst_inhouse_act))/100","v":1.8205128205128176E-2},null,null,null,null,"Total",{"$f":"cost_metro+cost_pop+cost_feeder+cost_manhole+cost_drop+cost_bep+cost_inhouse+cost_home","v":41738909.569821291}]
[null,"Surface per manhole",{"$f":"PI()*POWER(dist_drop_max_act,2)","v":0.38484510006474959},{"$f":"PI()*POWER(dist_drop_max_fut,2)","v":3.1415926535897934E-2},{"$f":"(100-(100/surface_manh_fut*surface_manh_act))/100","v":-11.249999999999995}]
[null,"Nb. \"Manhole\" location",{"$f":"ROUNDUP(Surface/surface_manh_act,0)","v":66},{"$f":"ROUNDUP(Surface/surface_manh_fut,0)","v":797},{"$f":"(100-(100/nb_manhole_fut*nb_manhole_act))/100","v":0.91718946047678795}]
[null,"Nb. \"Manhole\" bricks",{"$f":"(ROUNDUP(((act_lodgment/nb_manhole_act)/LOOKUP(act_manhole,TableInterconnection[ID],TableInterconnection[Ports per unit])),0)*nb_manhole_act)","v":66},{"$f":"(ROUNDUP(((fut_lodgment/nb_manhole_fut)/LOOKUP(fut_manhole,TableInterconnection[ID],TableInterconnection[Ports per unit])),0)*nb_manhole_fut)","v":2391},{"$f":"(100-(100/nb_manhole_elt_fut*nb_manhole_elt_act))/100","v":0.9723964868255961}]
[null,"Nb. BEP bricks",{"$f":"act_building","v":18672},{"$f":"fut_building","v":19000},{"$f":"(100-(100/nb_bep_fut*nb_bep_act))/100","v":1.726315789473688E-2}]
[null,"Nb. Home bricks",{"$f":"act_lodgment","v":95725},{"$f":"fut_lodgment","v":97500},{"$f":"(100-(100/nb_home_fut*nb_home_act))/100","v":1.8205128205128176E-2}]
[null,"Lodgements per building",{"$f":"act_lodgment/act_building","v":5.1266602399314483},{"$f":"fut_lodgment/fut_building","v":5.1315789473684212},{"$f":"(100-(100/D29*C29))/100","v":9.5851734669224694E-4}]
[null,"Manhole location per CO",{"$f":"nb_manhole_act/nb_co","v":6.6},{"$f":"nb_manhole_fut/nb_co","v":79.7},{"$f":"(100-(100/D30*C30))/100","v":0.91718946047678795}]
[null,"Lodgements per CO ",{"$f":"act_lodgment/nb_pops","v":9572.5},{"$f":"fut_lodgment/nb_pops","v":9750},{"$f":"(100-(100/nb_lodg_pop_fut*nb_lodg_pop_act))/100","v":1.8205128205128176E-2}]
[null,"Lodgements per manhole location",{"$f":"act_lodgment/nb_manhole_act","v":1450.378787878788},{"$f":"fut_lodgment/nb_manhole_fut","v":122.33375156838143},{"$f":"(100-(100/D32*C32))/100","v":-10.855916860916862}]
[null,"Buildings per manhole location",{"$f":"act_building/nb_manhole_act","v":282.90909090909093},{"$f":"fut_building/nb_manhole_fut","v":23.839397741530739},{"$f":"(100-(100/D33*C33))/100","v":-10.867291866028712}]

{"sheet":"Transmission","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["ID","Type","Name","Description","Km cost","Km installation cost","Total km cost"]
[1,"Metro","Fiber Optic (4 FO)","1 fibers in 4 FO cable + 1 installation for 1 cable in same tube",{"$f":"820*0.7","v":574},7500,{"$f":"TableTransmission[[#This Row],[Km cost]]+TableTransmission[[#This Row],[Km installation cost]]","v":8074}]
[2,"Feeder","Fiber Optic (432 FO / tube)","432 FO cable + installation for 1 cable in same tube",{"$f":"21490*0.7","v":15042.999999999998},7500,{"$f":"TableTransmission[[#This Row],[Km cost]]+TableTransmission[[#This Row],[Km installation cost]]","v":22543}]
[3,"Drop","Copper pair","already exists",0,0,{"$f":"TableTransmission[[#This Row],[Km cost]]+TableTransmission[[#This Row],[Km installation cost]]","v":0}]
[4,"Drop","Fiber Optic FTTH (48 FO / tube)","48 FO cable + installation for 1 cable in same tube",{"$f":"3720*0.7","v":2604},{"$f":"5000+1500/dst_drop_fut","v":5000.7894736842109},{"$f":"TableTransmission[[#This Row],[Km cost]]+TableTransmission[[#This Row],[Km installation cost]]","v":7604.7894736842109}]
[5,"InHouse","Optical fiber","4 fibers in 4 FO cable + BEP to CPE work",{"$f":"1210*0.7","v":847},5000,{"$f":"TableTransmission[[#This Row],[Km cost]]+TableTransmission[[#This Row],[Km installation cost]]","v":5847}]
[6,"InHouse","Copper pair","already exists",0,0,{"$f":"TableTransmission[[#This Row],[Km cost]]+TableTransmission[[#This Row],[Km installation cost]]","v":0}]
[7,"Feeder","Fiber Optic (4 FO / tube)","2 fiber in 4 FO cable + installation for 1 cable in same tube",{"$f":"820*0.7","v":574},7500,{"$f":"TableTransmission[[#This Row],[Km cost]]+TableTransmission[[#This Row],[Km installation cost]]","v":8074}]
[8,"Drop","Coax distribution","already exists",2000,5000,{"$f":"TableTransmission[[#This Row],[Km cost]]+TableTransmission[[#This Row],[Km installation cost]]","v":7000}]
[9,"InHouse","Coax indoor","already exists",1000,5000,{"$f":"TableTransmission[[#This Row],[Km cost]]+TableTransmission[[#This Row],[Km installation cost]]","v":6000}]
[10,"Feeder","Fiber Optic (288 FO / tube)","288 FO cable + installation for 1 cable in same tube",{"$f":"17000*0.7","v":11900},7500,{"$f":"TableTransmission[[#This Row],[Km cost]]+TableTransmission[[#This Row],[Km installation cost]]","v":19400}]
[11,"Feeder","Fiber Optic (576 FO / tube)","576 FO cable + installation for 1 cable in same tube",{"$f":"31870*0.7","v":22309},7500,{"$f":"TableTransmission[[#This Row],[Km cost]]+TableTransmission[[#This Row],[Km installation cost]]","v":29809}]
[12,"Drop","Fiber Optic (4 FO / tube)","2 FO cable + installation for 1 cable in same tube",{"$f":"4560*0.7","v":3192},{"$f":"5000+1500/drop_dst_fut","v":20000},{"$f":"TableTransmission[[#This Row],[Km cost]]+TableTransmission[[#This Row],[Km installation cost]]","v":23192}]
[13,"Feeder","Fiber Optic (4 FO / tube)","2 FO cable + installation for 1 cable in same tube",{"$f":"820*0.7","v":574},7500,{"$f":"TableTransmission[[#This Row],[Km cost]]+TableTransmission[[#This Row],[Km installation cost]]","v":8074}]

{"sheet":"Compatibility","index":3,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
["Transmission ID","Transmission Type","Transmission Name","Interconnection ID","Interconnection Type","Interconnection Name","Lookup"]
[1,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Metro"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Fiber Optic (4 FO)"},11,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"POP"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"Optical Switch (1500 x 1G + 2 x 40G)"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"1;11"}]
[1,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Metro"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Fiber Optic (4 FO)"},1,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"POP"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"Optical Switch (500 x 1G + 2 x 10G)"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"1;1"}]
[1,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Metro"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Fiber Optic (4 FO)"},2,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"POP"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"Optical Switch (48 x 1G + 1 x 1G)"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"1;2"}]
[1,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Metro"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Fiber Optic (4 FO)"},16,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"POP"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"Optical Switch (250 x 1G + 2 x 10G)"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"1;16"}]
[1,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Metro"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Fiber Optic (4 FO)"},22,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"POP"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"Optical Switch PON (150 ports with 64 clients + 2 x 40G)"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"1;22"}]
[11,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Feeder"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Fiber Optic (576 FO / tube)"},11,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"POP"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"Optical Switch (1500 x 1G + 2 x 40G)"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"11;11"}]
[2,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Feeder"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Fiber Optic (432 FO / tube)"},11,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"POP"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"Optical Switch (1500 x 1G + 2 x 40G)"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"2;11"}]
[11,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Feeder"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Fiber Optic (576 FO / tube)"},3,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"Manhole"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"DSLAM VDSL (1500 clients + 2 x 1G)"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"11;3"}]
[3,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Drop"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Copper pair"},3,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"Manhole"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"DSLAM VDSL (1500 clients + 2 x 1G)"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"3;3"}]
[4,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Drop"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Fiber Optic FTTH (48 FO / tube)"},4,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"Manhole"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"Optical splice"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"4;4"}]
[13,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Feeder"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Fiber Optic (4 FO / tube)"},23,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"POP"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"Optical Switch (24 x 1G + 1x 1G)"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"13;23"}]
[1,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Metro"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Fiber Optic (4 FO)"},23,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"POP"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"Optical Switch (24 x 1G + 1x 1G)"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"1;23"}]
[3,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Drop"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Copper pair"},5,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"BEP"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"BEP copper pair"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"3;5"}]
[3,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Drop"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Copper pair"},3,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"Manhole"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"DSLAM VDSL (1500 clients + 2 x 1G)"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"3;3"}]
[13,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Feeder"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Fiber Optic (4 FO / tube)"},3,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"Manhole"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"DSLAM VDSL (1500 clients + 2 x 1G)"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"13;3"}]
[6,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"InHouse"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Copper pair"},5,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"BEP"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"BEP copper pair"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"6;5"}]
[6,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"InHouse"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Copper pair"},8,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"Home"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"VDSL modem"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"6;8"}]
[5,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"InHouse"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Optical fiber"},6,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"Home"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"FTTH modem"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"5;6"}]
[5,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"InHouse"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Optical fiber"},7,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"BEP"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"BEP optical fiber"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"5;7"}]
[4,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Drop"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Fiber Optic FTTH (48 FO / tube)"},7,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"BEP"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"BEP optical fiber"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"4;7"}]
[11,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Feeder"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Fiber Optic (576 FO / tube)"},4,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"Manhole"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"Optical splice"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"11;4"}]
[6,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"InHouse"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Copper pair"},10,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"Home"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"G.fast modem"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"6;10"}]
[3,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Drop"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Copper pair"},9,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"Manhole"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"DSLAM G.fast (48 clients + 1 x 10G)"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"3;9"}]
[13,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Feeder"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Fiber Optic (4 FO / tube)"},9,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"Manhole"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"DSLAM G.fast (48 clients + 1 x 10G)"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"13;9"}]
[13,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Feeder"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Fiber Optic (4 FO / tube)"},24,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"POP"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"Optical Switch (96 x 10G + 2 x 40 G)"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"13;24"}]
[1,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Type])","v":"Metro"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Transmission ID]],TableTransmission[ID],TableTransmission[Name])","v":"Fiber Optic (4 FO)"},24,{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Type])","v":"POP"},{"$f":"LOOKUP(TableCompatibility[[#This Row],[Interconnection ID]], TableInterconnection[ID], TableInterconnection[Name])","v":"Optical Switch (96 x 10G + 2 x 40 G)"},{"$f":"TableCompatibility[[#This Row],[Transmission ID]]&\";\"&TableCompatibility[[#This Row],[Interconnection ID]]","v":"1;24"}]

{"sheet":"Interconnection","index":4,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["ID","Type","Name","Description","Initial cost per port","Installation cost","Ports per unit","Total initial cost","Downstream [Mb/s]"]
[1,"POP","Optical Switch (500 x 1G + 2 x 10G)",null,{"$f":"((5000+2*600)/TableInterconnection[[#This Row],[Ports per unit]]+100)","v":112.4},0,500,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":56200},20000]
[2,"POP","Optical Switch (48 x 1G + 1 x 1G)",null,{"$f":"((8500+100)/TableInterconnection[[#This Row],[Ports per unit]])","v":179.16666666666666},0,48,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":8600},2000]
[3,"Manhole","DSLAM VDSL (1500 clients + 2 x 1G)","already exists",0,0,1500,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":0},2000]
[4,"Manhole","Optical splice","optical splice + manhole installation",20,0,1,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":20}]
[5,"BEP","BEP copper pair",null,0,0,1,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":0}]
[6,"Home","FTTH modem",null,150,null,1,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":150}]
[7,"BEP","BEP optical fiber",null,150,0,1,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":150}]
[8,"Home","VDSL modem","already exists",0,0,1,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":0},200]
[9,"Manhole","DSLAM G.fast (48 clients + 1 x 10G)",null,150,0,48,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":7200},10000]
[10,"Home","G.fast modem",null,150,0,1,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":150}]
[11,"POP","Optical Switch (1500 x 1G + 2 x 40G)",null,{"$f":"((5000+2*2000)/TableInterconnection[[#This Row],[Ports per unit]]+100)","v":106},0,1500,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":159000},80000]
[12,"Manhole","CMTS DOCSIS 3.1 (24 islet of 50 clients + 1 x 10G FO)",null,{"$f":"150*24","v":3600},0,24,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":86400},10000]
[13,"Manhole","CMTS DOCSIS 3.1 (48 islet of 50 clients + 2 x 10G FO)",null,{"$f":"150*48","v":7200},0,48,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":345600},20000]
[14,"Manhole","CMTS DOCSIS 3.0 (24 islet of 100 clients + 1 x 1G FO)","already exists",0,0,24,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":0},0]
[15,"Manhole","CMTS DOCSIS 3.0 (48 islet of 100 clients + 1 x 1G FO)","already exists",null,0,48,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":0},0]
[16,"POP","Optical Switch (250 x 1G + 2 x 10G)","optical switch chassis + 1G port + 10G ports",{"$f":"(5000+2*600)/TableInterconnection[[#This Row],[Ports per unit]]+100","v":124.8},0,250,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":31200},20000]
[17,"BEP","Coaxial","already exists",0,0,1,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":0}]
[18,"BEP","PON splitter 1:8 ",null,{"$f":"20","v":20},0,8,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":160},10000]
[19,"BEP","PON splitter 1:4",null,20,0,4,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":80},10000]
[20,"Manhole","PON splitter 1:16",null,20,0,16,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":320},10000]
[21,"Manhole","PON splitter 1:8 ",null,20,0,8,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":160},10000]
[22,"POP","Optical Switch PON (150 ports with 64 clients + 2 x 40G)",null,{"$f":"(5000+2*2000)/TableInterconnection[[#This Row],[Ports per unit]]+400","v":460},0,150,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":69000}]
[23,"POP","Optical Switch (24 x 1G + 1x 1G)",null,{"$f":"(4500+100)/TableInterconnection[[#This Row],[Ports per unit]]","v":191.66666666666666},null,24,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":4600}]
[24,"POP","Optical Switch (96 x 10G + 2 x 40 G)","optical switch chassis + 10G port + 40G ports",{"$f":"(5000+2*2000)/TableInterconnection[[#This Row],[Ports per unit]]+600","v":693.75},0,96,{"$f":"TableInterconnection[[#This Row],[Initial cost per port]]*TableInterconnection[[#This Row],[Ports per unit]]+TableInterconnection[[#This Row],[Installation cost]]","v":66600},80000]

{"sheet":"Cost per Section","index":5,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,"Metro","Feeder","Drop","InHouse","Home"]
["Interconnection",0,{"$f":"cost_pop/1000","v":1998},{"$f":"(cost_manhole)/1000","v":17215.2},{"$f":"cost_bep/1000","v":0},{"$f":"cost_home/1000","v":14625}]
["Transmission",{"$f":"cost_metro/1000","v":0},{"$f":"cost_feeder/1000","v":7900.7095698212906},{"$f":"cost_drop/1000","v":0},{"$f":"cost_inhouse/1000","v":0},0]

{"sheet":"Cost Distance drop","index":6,"n_rows":101,"n_cols":7,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["Distance drop max","Nb lodgments per manhole","Nb buildings per manhole","Cost feeder","Cost drop","Total Cost","Min"]
[1,12187.5,2375,1998000,14630400,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16628400},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G3:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.99,10833.333333333334,2111.1111111111113,1998000,14644800,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16642800},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G4:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.98,10833.333333333334,2111.1111111111113,1998000,14644800,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16642800},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G5:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.97,10833.333333333334,2111.1111111111113,1998000,14644800,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16642800},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G6:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.96,10833.333333333334,2111.1111111111113,1998000,14644800,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16642800},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G7:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.95,10833.333333333334,2111.1111111111113,1998000,14644800,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16642800},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G8:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.94,9750,1900,1998000,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16686000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G9:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.93,9750,1900,1998000,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16686000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G10:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.92,9750,1900,1998000,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16686000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G11:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.91,9750,1900,1998000,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16686000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G12:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.9,9750,1900,1998000,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16686000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G13:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.89,8863.636363636364,1727.2727272727273,1998000,14652000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16650000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G14:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.88,8863.636363636364,1727.2727272727273,1998000,14652000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16650000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G15:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.87,8863.636363636364,1727.2727272727273,1998000,14652000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16650000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G16:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.86,8863.636363636364,1727.2727272727273,1998000,14652000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16650000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G17:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.85,8125,1583.3333333333333,1998000,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16686000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G18:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.84,8125,1583.3333333333333,1998000,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16686000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G19:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.83,8125,1583.3333333333333,1998000,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16686000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G20:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.82,8125,1583.3333333333333,1998000,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16686000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G21:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.81,7500,1461.5384615384614,1998000,14695200,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16693200},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G22:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.8,7500,1461.5384615384614,1998000,14695200,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16693200},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G23:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.79,7500,1461.5384615384614,1998000,14695200,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16693200},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G24:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.78,6964.2857142857147,1357.1428571428571,1998000,14716800,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16714800},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G25:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.77,6964.2857142857147,1357.1428571428571,1998000,14716800,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16714800},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G26:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.76,6964.2857142857147,1357.1428571428571,1998000,14716800,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16714800},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G27:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.75,6500,1266.6666666666667,1998000,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16686000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G28:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.74,6500,1266.6666666666667,1998000,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16686000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G29:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.73,6500,1266.6666666666667,1998000,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16686000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G30:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.72,6093.75,1187.5,1998000,14630400,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16628400},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G31:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.71,6093.75,1187.5,1998000,14630400,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16628400},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G32:$G$99)=0,1,\"\"),\"\")","v":1}]
[0.7,5735.2941176470586,1117.6470588235295,1998000,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16686000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G33:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.69,5735.2941176470586,1117.6470588235295,1998000,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16686000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G34:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.68,5416.666666666667,1055.5555555555557,1998000,14644800,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16642800},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G35:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.67,5416.666666666667,1055.5555555555557,1998000,14644800,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16642800},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G36:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.66,5131.5789473684208,1000,1998000,14637600,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16635600},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G37:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.65,5131.5789473684208,1000,1998000,14637600,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16635600},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G38:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.64,4875,950,1998000,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16686000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G39:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.63,4642.8571428571431,904.76190476190482,1998000,14666400,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16664400},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G40:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.62,4642.8571428571431,904.76190476190482,1998000,14666400,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16664400},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G41:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.61,4431.818181818182,863.63636363636363,1998000,14731200,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16729200},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G42:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.6,4239.130434782609,826.08695652173913,1998000,14738400,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16736400},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G43:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.59,4239.130434782609,826.08695652173913,1998000,14738400,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16736400},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G44:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.57999999999999996,4062.5,791.66666666666663,1998000,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16686000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G45:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.56999999999999995,3900,760,1998000,14760000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16758000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G46:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.56000000000000005,3750,730.76923076923072,1998000,14788800,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16786800},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G47:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.55000000000000004,3611.1111111111113,703.7037037037037,1998000,14774400,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16772400},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G48:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.54,3482.1428571428573,678.57142857142856,1998000,14716800,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16714800},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G49:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.53,3362.0689655172414,655.17241379310349,1998000,14824800,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16822800},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G50:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.52,3250,633.33333333333337,1998000,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16686000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G51:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.51,3145.1612903225805,612.90322580645159,1998000,14731200,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16729200},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G52:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.5,3046.875,593.75,1998000,14745600,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16743600},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G53:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.49,2867.6470588235293,558.82352941176475,1998000,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16686000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G54:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.48,2785.7142857142858,542.85714285714289,1998000,14868000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16866000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G55:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.47,2635.135135135135,513.51351351351354,1998000,14652000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16650000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G56:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.46,2565.7894736842104,500,1998000,14774400,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16772400},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G57:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.45,2437.5,475,1998000,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16686000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G58:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.44,2321.4285714285716,452.38095238095241,1998000,14817600,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16815600},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G59:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.42999999999999899,2215.909090909091,431.81818181818181,1998000,14889600,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16887600},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G60:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.41999999999999899,2119.5652173913045,413.04347826086956,1998000,14904000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16902000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G61:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.40999999999999898,2031.25,395.83333333333331,1998000,14860800,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16858800},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G62:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.39999999999999902,1950,380,1998000,14760000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16758000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G63:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.38999999999999901,1839.6226415094341,358.49056603773585,1998000,14882400,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16880400},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G64:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.37999999999999901,1741.0714285714287,339.28571428571428,1998000,14918400,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16916400},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G65:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.369999999999999,1652.542372881356,322.03389830508473,1998000,14868000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16866000},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G66:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.35999999999999899,1572.5806451612902,306.45161290322579,1998000,14731200,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16729200},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G67:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.34999999999999898,1477.2727272727273,287.87878787878788,1998000,14731200,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16729200},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G68:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.33999999999999903,1413.0434782608695,275.36231884057969,2030424.2526805252,14904000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16934424.252680525},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G69:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.32999999999999902,1317.5675675675675,256.75675675675677,2084464.6738147337,14918400,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":17002864.673814733},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G70:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.31999999999999901,1250,243.58974358974359,2127697.0107221007,15163200,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":17290897.010722101},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G71:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.309999999999999,1174.698795180723,228.9156626506024,2181737.4318563091,14940000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":17121737.431856308},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G72:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.29999999999999899,1095.5056179775281,213.48314606741573,2246585.9372173594,14738400,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":16984985.937217358},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G73:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.28999999999999898,1026.3157894736842,200,2311434.4425784098,15048000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":17359434.442578409},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G74:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.27999999999999903,955.88235294117646,186.27450980392157,2387091.0321663017,14688000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":17075091.032166302},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G75:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.26999999999999902,886.36363636363637,172.72727272727272,2473555.7059810353,15048000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":17521555.705981035},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G76:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.25999999999999901,826.27118644067798,161.01694915254237,2560020.3797957692,15292800,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":17852820.379795767},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G77:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.249999999999999,761.71875,148.4375,2668101.2220641859,14745600,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":17413701.222064186},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G78:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.23999999999999899,701.43884892086328,136.69064748201438,2786990.148559445,15012000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":17798990.148559444},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G79:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.22999999999999901,645.69536423841055,125.82781456953643,2916687.1592815453,15220800,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":18137487.159281544},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G80:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.219999999999999,590.90909090909088,115.15151515151516,3068000.3384573292,15444000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":18512000.338457331},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G81:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.20999999999999899,538.67403314917124,104.97237569060773,3240929.6860867972,15638400,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":18879329.686086796},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G82:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.19999999999999901,487.5,95,3446283.2863967894,15840000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":19286283.28639679},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G83:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.189999999999999,441.1764705882353,85.972850678733025,3673253.0551604652,15912000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":19585253.055160467},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G84:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.17999999999999899,396.34146341463412,77.235772357723576,3943455.1608315082,15940800,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":19884255.160831507},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G85:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.16999999999999901,353.26086956521738,68.840579710144922,4267697.6876367591,15897600,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":20165297.687636759},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G86:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.159999999999999,312.5,60.897435897435898,4656788.7198030613,15724800,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":20381588.719803061},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G87:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.149999999999999,275.42372881355931,53.672316384180789,5110728.257330413,15292800,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":20403528.257330414},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G88:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.13999999999999899,239.55773955773955,46.683046683046683,5683556.7213530242,14652000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":20335556.721353024},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G89:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.12999999999999901,206.56779661016949,40.254237288135592,6386082.1960977353,16992000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":23378082.196097735},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G90:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.119999999999999,175.9927797833935,34.296028880866423,7272345.1026987555,15955200,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":23227545.102698755},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G91:$G$99)=0,1,\"\"),\"\")","v":""}]
[0.109999999999999,147.95144157814872,28.83156297420334,8407193.9465171359,18979200,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":27386393.946517136},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G92:$G$99)=0,1,\"\"),\"\")","v":""}]
[9.9999999999999006E-2,122.33375156838143,23.839397741530739,9898709.5698212907,17215200,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":27113909.569821291},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G93:$G$99)=0,1,\"\"),\"\")","v":""}]
[8.9999999999998997E-2,99.08536585365853,19.308943089430894,12585821.320240691,21254400,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":33840221.320240691},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G94:$G$99)=0,1,\"\"),\"\")","v":""}]
[7.9999999999999002E-2,78.313253012048193,15.261044176706827,14740731.303446377,17928000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":32668731.303446375},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G95:$G$99)=0,1,\"\"),\"\")","v":""}]
[6.9999999999998994E-2,59.963099630996311,11.685116851168512,19524611.393873069,23414400,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":42939011.393873066},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G96:$G$99)=0,1,\"\"),\"\")","v":""}]
[5.9999999999999103E-2,44.057840036150026,8.5856303660189788,25202956.835029155,15933600,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":41136556.835029155},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G97:$G$99)=0,1,\"\"),\"\")","v":""}]
[4.9999999999998997E-2,30.602636534839924,5.9635907093534213,36385222.787746139,22939200,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":59324422.787746139},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G98:$G$99)=0,1,\"\"),\"\")","v":""}]
[3.9999999999999002E-2,19.586179188429089,3.8167938931297711,57085309.72224649,35841600,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":92926909.722246498},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G99:$G$99)=0,1,\"\"),\"\")","v":""}]
[2.9999999999999E-2,11.016949152542374,2.1468926553672318,101598211.84857759,63720000,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":165318211.84857759},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G$99:$G100)=0,1,\"\"),\"\")","v":""}]
[1.9999999999999001E-2,4.8967907186982069,0.95424639646426601,228472431.48167375,143359200,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":371831631.48167372},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),IF(SUM(G$99:$G101)=0,1,\"\"),\"\")","v":""}]
[9.9999999999990097E-3,1.2242284221892972,0.23856758996509381,915342110.43515599,573422400,{"$f":"TableCostRatio[[#This Row],[Cost feeder]]+TableCostRatio[[#This Row],[Cost drop]]","v":1488764510.4351559},{"$f":"IF(TableCostRatio[[#This Row],[Total Cost]]=MIN(TableCostRatio[Total Cost]),\"1\",\"\")","v":""}]

{"sheet":"Demography","index":7,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"Actual","Future"]
["Year",{"$f":"act_year","v":2013},{"$f":"fut_year","v":2025}]
["Lodgment",{"$f":"act_lodgment","v":95725},{"$f":"fut_lodgment-B3","v":1775}]
["Building",{"$f":"act_building","v":18672},{"$f":"fut_building-B4","v":328}]